WiltonDB

Modified PostgreSQL with Babelfish extensions packaged for Windows and Linux.

Link to documentation.

News

2024-05-16

WiltonDB 3.3 update (version 8.13.1) is released for Windows and Linux.

Bugfixes:

• this release includes a fix to CVE-2024-4317 from upstream PostgreSQL 15.7. To apply the fix to existing DB clusters it is necessary to run <installdir>/share/fix-CVE-2024-4317.sql script on Postgres connection (default port 5432)
• #2540 fix is backported from upstream Babelfish. It fixes the problem when altering a table to add a column with DEFAULT NEWID() makes the values all the same value which is not the correct behaviour. To apply the fix to existing DB cluster it is necessary to run the following SQL on Postgres connection (default port 5432):

ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.2'

Notable changes:

• support for ALTER AUTHORIZATION ON DATABASE::<dbname> TO <login-name> (#1954) is backported from upstream Babelfish. It allows to easily create login-owned databases, see details on Logins and users wiki page
• support for FOR JSON AUTO (#2243) is backported from upstream Babelfish
• default TDS debug logging, which was creating multiple log records for every connection, is disabled; this behaviour can be controlled by changing babelfishpg_tds.tds_debug_log_level system parameter from 0 (disabled) to 3 (max verbosity)

2024-04-15

WiltonDB 3.3 update (version 7.12.1) is released for Windows and Linux.

Changes:

• a number of fixes in BCP import area (#2422, #2455, #2462, #2468, #2486)
• mimalloc allocator is added on Windows to improve ANTLR memory handling, this makes DB connection initialization 10-15% faster
• system_stats extension is included with Windows installer and Linux packages, see details about its usage in Database-monitoring

2024-03-29

Initial version of WiltonDB Data Transfer GUI tool is released.

WiltonDB 3.3 update (version 6.11.1) is released for Windows. This update includes a Windows-only fix to intermittent problem with BCP imports (#13).

2024-03-17

WiltonDB 3.3 update (version 5.10.1) is released for Windows and Linux.

This update includes two notable bugfixes from upstream Babelfish - #1957 and #2017. The former one introduces additional CASTs in babelfishpg_common extension, its version is bumped from 3.3.0 to 3.3.1. When performing the upgrade from previous versions of WiltonDB 3.3 (using existing DB cluster), it is necessary to run the following SQL on Postgres connection (port 5432 by default):

ALTER EXTENSION "babelfishpg_common" UPDATE TO '3.3.1'

2024-03-02

WiltonDB 3.3 update (version 4.9.1) is released for Windows and Linux.

With this update Linked Servers and OPENQUERY functionality is now supported in Linux packages the same way it works on Windows (issue #9).

This update includes bugfixes to issues #10 and #11. This requires minor changes to stored procedures and views in babelfishpg_tsql extension, its version is bumped from 3.3.0 to 3.3.1. When performing the upgrade from previous versions of WiltonDB 3.3 (using existing DB cluster), it is necessary to run the following SQL on Postgres connection (port 5432 by default):

ALTER EXTENSION "babelfishpg_tsql" UPDATE TO '3.3.1'

2024-02-23

WiltonDB 3.3 update (version 4.7.1) is released for Windows.

This update includes support for Linked Servers and OPENQUERY.

2024-02-12

WiltonDB 3.3 update (version 4.6.1) is released for Windows and Linux.

With this update plain ZIP bundle is provided for Windows that can be used to set up and run WiltonDB under non-privileged user.

This update includes a security fix from PostgreSQL 15.6 and a critical fix from BABEL_3_3_STABLE branch of the upstream Babelfish.

2024-01-17

Initial version of WiltonDB Backup GUI tool is released. Description about it is added to documentation along with more broad article about backup and restore.

2023-12-31

WiltonDB 3.3 update (version 3.5.1) is released.

This update includes security fixes from PostgreSQL 15.5 and critical fixes from BABEL_3_3_STABLE branch of the upstream Babelfish.

The update is released for Windows and Linux including Ubuntu 23.10 (in preparation for Ubuntu 24.04 LTS) and a stable version for Fedora x86_64.

2023-11-15

WiltonDB is covered on postgresql.org.

2023-11-05

Initial version of WiltonDB 3.3 is released for Windows and Linux.

License information

WiltonDB is released under the Apache-2.0 or PostgreSQL license at your choice. Use is permitted under either license.